Curio: A Novel Solution for Efficient Storage and Indexing in Data Warehouses

نویسندگان

  • Anindya Datta
  • Krithi Ramamritham
  • Helen M. Thomas
چکیده

Data warehousing and On-Line Analytical Processing (OLAP) are becoming critical components of decision support as advances in technology are improving the ability to manage and retrieve large volumes of data. Data warehousing refers to \a collection of decision support technologies aimed at enabling the knowledge worker (executive, manager, analyst) to make better and faster decisions" [1]. OLAP refers to the technique of performing complex analysis over the information stored in a data warehouse. It is often used by management analysts and decision makers in a variety of functional areas such as sales and marketing planning. Typically, OLAP queries look for speci c trends and anomalies in the base information by aggregating, ranging, ltering and grouping data in many di erent ways [8]. E cient query processing is a critical requirement for OLAP because the underlying data warehouse is very large, queries are often quite complex, and decision support applications typically require in-

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

PartJoin: An Efficient Storage and Query Execution for Data Warehouses

The performance of OLAP queries can be improved drastically if the warehouse data is properly selected and indexed. The problems of selecting and materializing views and indexing data have been studied extensively in the data warehousing environment. On the other hand, data partitioning can also greatly increase the performance of queries. Data partitioning has advantage over data selection and...

متن کامل

Fuzzy multi-criteria selection procedures in choosing data source

Technology assessment and selection has a substantial impact on organizations procedures in regards to technology transfer. Technological decisions are usually made by a group of experts, and whereby integrity of these viewpoints to a single decision can be quite complex. Today, operational databases and data warehouses exist to manage and organize data with specific features and henceforth, th...

متن کامل

An EOQ model for non-instantaneous deteriorating items with two levels of storage under trade credit policy

A deterministic inventory model with two levels of storage (own warehouse and rented warehouse) with non-instantaneous deteriorating items is studied. The supplier offers the retailer a trade credit period to settle the amount. Different scenarios based on the deterioration and the trade credit period have been considered. In this article, we have framed two models considering single warehouse ...

متن کامل

Research Statement 1 Self-tuning Databases 1.1 Workload-driven Schema Partitioning 1.2 New Models and Algorithms for Database Design

My research is motivated by the challenge of managing massive data. As diverse scientific fields such as astronomy and computational mechanics accumulate observational or experimental data, large-scale data management is expected to be the “limiting or the enabling factor for a wide range of sciences” [3]. The same holds for modern enterprises, which rely on massive data warehouses for business...

متن کامل

Stored-grains pests and their control with emphasis on military food warehouses in Iran: a review

Background and Aim: In order to providing healthy food and improve food security, it is vital to preserve and protect agricultural products from pest's damage during storage. This is especially crucial for strategic products such as grains and cereals. Inefficient management in this subject would lead to the loss of stored food and will make the country's economic dependence on the other. In pa...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

عنوان ژورنال:

دوره   شماره 

صفحات  -

تاریخ انتشار 1999